Overview

Dataset Statistics

Number of Variables 23
Number of Rows 34508
Missing Cells 109086
Missing Cells (%) 13.7%
Duplicate Rows 0
Duplicate Rows (%) 0.0%
Total Size in Memory 23.5 MB
Average Row Size in Memory 714.6 B
Variable Types
  • Numerical: 11
  • Categorical: 12

Dataset Insights

DonorUniqueId is uniformly distributed Uniform
LastFiscalYearDonation and Donation2FiscalYearsAgo have similar distributions Similar Distribution
LastFiscalYearDonation and Donation3FiscalYearsAgo have similar distributions Similar Distribution
LastFiscalYearDonation and Donation4FiscalYearsAgo have similar distributions Similar Distribution
LastFiscalYearDonation and Donation5FiscalYearsAgo have similar distributions Similar Distribution
LastFiscalYearDonation and CurrentFiscalYearDonation have similar distributions Similar Distribution
Donation2FiscalYearsAgo and Donation3FiscalYearsAgo have similar distributions Similar Distribution
Donation2FiscalYearsAgo and Donation4FiscalYearsAgo have similar distributions Similar Distribution
Donation2FiscalYearsAgo and Donation5FiscalYearsAgo have similar distributions Similar Distribution
Donation2FiscalYearsAgo and CurrentFiscalYearDonation have similar distributions Similar Distribution
Donation3FiscalYearsAgo and Donation4FiscalYearsAgo have similar distributions Similar Distribution
Donation3FiscalYearsAgo and Donation5FiscalYearsAgo have similar distributions Similar Distribution
Donation3FiscalYearsAgo and CurrentFiscalYearDonation have similar distributions Similar Distribution
Donation4FiscalYearsAgo and Donation5FiscalYearsAgo have similar distributions Similar Distribution
Donation4FiscalYearsAgo and CurrentFiscalYearDonation have similar distributions Similar Distribution
Donation5FiscalYearsAgo and CurrentFiscalYearDonation have similar distributions Similar Distribution
MaritalStatus has 24568 (71.2%) missing values Missing
GenderIdentity has 493 (1.43%) missing values Missing
WealthRating has 31799 (92.15%) missing values Missing
AcademicDegreeLevel has 26902 (77.96%) missing values Missing
PreferredAddressType has 4043 (11.72%) missing values Missing
DonorDateOfBirth has 21190 (61.41%) missing values Missing
DonorUniqueId is skewed Skewed
DonorPostalCode is skewed Skewed
DonorAge is skewed Skewed
ConsecutiveDonorYears is skewed Skewed
LastFiscalYearDonation is skewed Skewed
Donation2FiscalYearsAgo is skewed Skewed
Donation3FiscalYearsAgo is skewed Skewed
Donation4FiscalYearsAgo is skewed Skewed
Donation5FiscalYearsAgo is skewed Skewed
CurrentFiscalYearDonation is skewed Skewed
CumulativeDonationAmount is skewed Skewed
DonorDateOfBirth has a high cardinality: 4812 distinct values High Cardinality
IsMemberFlag has constant value "N" Constant
IsMemberFlag has constant length 1 Constant Length
IsAlumnusFlag has constant length 1 Constant Length
IsParentFlag has constant length 1 Constant Length
HasInvolvementFlag has constant length 1 Constant Length
AcademicDegreeLevel has constant length 2 Constant Length
HasEmailFlag has constant length 1 Constant Length
DonorIndicatorFlag. has constant length 1 Constant Length
ConsecutiveDonorYears has 18236 (52.85%) zeros Zeros
LastFiscalYearDonation has 32139 (93.13%) zeros Zeros
Donation2FiscalYearsAgo has 32032 (92.82%) zeros Zeros
Donation3FiscalYearsAgo has 31971 (92.65%) zeros Zeros
Donation4FiscalYearsAgo has 32362 (93.78%) zeros Zeros
Donation5FiscalYearsAgo has 32544 (94.31%) zeros Zeros
CurrentFiscalYearDonation has 32599 (94.47%) zeros Zeros
CumulativeDonationAmount has 13075 (37.89%) zeros Zeros
  • 1
  • 2
  • 3
  • 4
  • 5

Variables


DonorUniqueId

numerical

Approximate Distinct Count 34508
Approximate Unique (%) 100.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 552128
Mean 17254.5
Minimum 1
Maximum 34508
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • DonorUniqueId is uniformly distributed

Quantile Statistics

Minimum 1
5-th Percentile 1726.35
Q1 8627.75
Median 17254.5
Q3 25881.25
95-th Percentile 32782.65
Maximum 34508
Range 34507
IQR 17253.5

Descriptive Statistics

Mean 17254.5
Standard Deviation 9961.7459
Variance 9.9236e+07
Sum 5.9542e+08
Skewness 0
Kurtosis -1.2
Coefficient of Variation 0.5773
  • DonorUniqueId is not normally distributed (p-value 7.3048560981256894e-06)

DonorPostalCode

numerical

Approximate Distinct Count 20991
Approximate Unique (%) 61.0%
Missing 91
Missing (%) 0.3%
Infinite 0
Infinite (%) 0.0%
Memory Size 550672
Mean 56161.626
Minimum 211
Maximum 99928
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • DonorPostalCode is skewed left (γ1 = -0.2166)

Quantile Statistics

Minimum 211
5-th Percentile 6837.6
Q1 29927
Median 58108
Q3 90265
95-th Percentile 94940.2
Maximum 99928
Range 99717
IQR 60338

Descriptive Statistics

Mean 56161.626
Standard Deviation 29966.7045
Variance 8.98e+08
Sum 1.9329e+09
Skewness -0.2166
Kurtosis -1.3063
Coefficient of Variation 0.5336
  • DonorPostalCode is not normally distributed (p-value 1.3611248718955277e-24)

DonorAge

numerical

Approximate Distinct Count 102
Approximate Unique (%) 0.3%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 552128
Mean 43.367
Minimum 1
Maximum 110
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • DonorAge is skewed right (γ1 = 1.4386)

Quantile Statistics

Minimum 1
5-th Percentile 26
Q1 42
Median 42
Q3 42
95-th Percentile 66
Maximum 110
Range 109
IQR 0

Descriptive Statistics

Mean 43.367
Standard Deviation 11.4057
Variance 130.0905
Sum 1.4965e+06
Skewness 1.4386
Kurtosis 4.2964
Coefficient of Variation 0.263
  • DonorAge is not normally distributed (p-value 6.20550595758114e-25)
  • DonorAge has 13036 outliers

MaritalStatus

categorical

Approximate Distinct Count 6
Approximate Unique (%) 0.1%
Missing 24568
Missing (%) 71.2%
Memory Size 712660
  • The largest value (Married) is over 2.09 times larger than the second largest value (Single)

Length

Mean 6.6962
Standard Deviation 0.4965
Median 7
Minimum 6
Maximum 13

Sample

1st row Married
2nd row Married
3rd row Married
4th row Single
5th row Married

Letter

Count 66557
Lowercase Letter 56614
Space Separator 3
Uppercase Letter 9943
Dash Punctuation 0
Decimal Number 0
  • The largest value (married) is over 2.09 times larger than the second largest value (single)

GenderIdentity

categorical

Approximate Distinct Count 5
Approximate Unique (%) 0.0%
Missing 493
Missing (%) 1.4%
Memory Size 2382606

Length

Mean 5.0457
Standard Deviation 0.9997
Median 6
Minimum 1
Maximum 7

Sample

1st row Female
2nd row Female
3rd row Female
4th row Female
5th row Female

Letter

Count 171631
Lowercase Letter 137616
Space Separator 0
Uppercase Letter 34015
Dash Punctuation 0
Decimal Number 0
  • The top 2 categories (Female, Male) take over 50.0%

IsMemberFlag

categorical

Approximate Distinct Count 1
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 2277528

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row N
2nd row N
3rd row N
4th row N
5th row N

Letter

Count 34508
Lowercase Letter 0
Space Separator 0
Uppercase Letter 34508
Dash Punctuation 0
Decimal Number 0
  • IsMemberFlag has words of constant length

IsAlumnusFlag

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 2277528
  • The largest value (N) is over 3.1 times larger than the second largest value (Y)

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row N
2nd row Y
3rd row N
4th row Y
5th row N

Letter

Count 34508
Lowercase Letter 0
Space Separator 0
Uppercase Letter 34508
Dash Punctuation 0
Decimal Number 0
  • The top 2 categories (N, Y) take over 50.0%
  • The largest value (n) is over 3.1 times larger than the second largest value (y)
  • IsAlumnusFlag has words of constant length

IsParentFlag

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 2277528
  • The largest value (N) is over 11.78 times larger than the second largest value (Y)

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row N
2nd row N
3rd row N
4th row N
5th row N

Letter

Count 34508
Lowercase Letter 0
Space Separator 0
Uppercase Letter 34508
Dash Punctuation 0
Decimal Number 0
  • The top 2 categories (N, Y) take over 50.0%
  • The largest value (n) is over 11.78 times larger than the second largest value (y)
  • IsParentFlag has words of constant length

HasInvolvementFlag

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 2277528
  • The largest value (N) is over 3.33 times larger than the second largest value (Y)

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row N
2nd row Y
3rd row N
4th row Y
5th row N

Letter

Count 34508
Lowercase Letter 0
Space Separator 0
Uppercase Letter 34508
Dash Punctuation 0
Decimal Number 0
  • The top 2 categories (N, Y) take over 50.0%
  • The largest value (n) is over 3.33 times larger than the second largest value (y)
  • HasInvolvementFlag has words of constant length

WealthRating

categorical

Approximate Distinct Count 8
Approximate Unique (%) 0.3%
Missing 31799
Missing (%) 92.2%
Memory Size 215912

Length

Mean 14.7017
Standard Deviation 2.7146
Median 15
Minimum 10
Maximum 21

Sample

1st row $50,000-$99,999
2nd row $50,000-$99,999
3rd row $50,000-$99,999
4th row $50,000-$99,999
5th row $100,000-$249,999

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 2709
Decimal Number 26736

AcademicDegreeLevel

categorical

Approximate Distinct Count 7
Approximate Unique (%) 0.1%
Missing 26902
Missing (%) 78.0%
Memory Size 509602

Length

Mean 2
Standard Deviation 0
Median 2
Minimum 2
Maximum 2

Sample

1st row UB
2nd row GP
3rd row UB
4th row GP
5th row GM

Letter

Count 15212
Lowercase Letter 0
Space Separator 0
Uppercase Letter 15212
Dash Punctuation 0
Decimal Number 0
  • AcademicDegreeLevel has words of constant length

PreferredAddressType

categorical

Approximate Distinct Count 4
Approximate Unique (%) 0.0%
Missing 4043
Missing (%) 11.7%
Memory Size 2102014
  • The largest value (HOME) is over 29.48 times larger than the second largest value (BUSN)

Length

Mean 3.9977
Standard Deviation 0.04822
Median 4
Minimum 3
Maximum 4

Sample

1st row HOME
2nd row HOME
3rd row HOME
4th row HOME
5th row HOME

Letter

Count 121789
Lowercase Letter 0
Space Separator 0
Uppercase Letter 121789
Dash Punctuation 0
Decimal Number 0
  • The top 2 categories (HOME, BUSN) take over 50.0%
  • The largest value (home) is over 29.48 times larger than the second largest value (busn)

HasEmailFlag

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 2277528
  • The largest value (N) is over 2.06 times larger than the second largest value (Y)

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row N
2nd row Y
3rd row N
4th row Y
5th row Y

Letter

Count 34508
Lowercase Letter 0
Space Separator 0
Uppercase Letter 34508
Dash Punctuation 0
Decimal Number 0
  • The top 2 categories (N, Y) take over 50.0%
  • The largest value (n) is over 2.06 times larger than the second largest value (y)
  • HasEmailFlag has words of constant length

ConsecutiveDonorYears

numerical

Approximate Distinct Count 33
Approximate Unique (%) 0.1%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 552128
Mean 1.1375
Minimum 0
Maximum 36
Zeros 18236
Zeros (%) 52.8%
Negatives 0
Negatives (%) 0.0%
  • ConsecutiveDonorYears is skewed right (γ1 = 5.1025)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 1
95-th Percentile 5
Maximum 36
Range 36
IQR 1

Descriptive Statistics

Mean 1.1375
Standard Deviation 2.423
Variance 5.8711
Sum 39252
Skewness 5.1025
Kurtosis 37.921
Coefficient of Variation 2.1302
  • ConsecutiveDonorYears is not normally distributed (p-value 1.4691613241543246e-20)
  • ConsecutiveDonorYears has 4066 outliers

LastFiscalYearDonation

numerical

Approximate Distinct Count 188
Approximate Unique (%) 0.5%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 552128
Mean 377.6168
Minimum 0
Maximum 10000000
Zeros 32139
Zeros (%) 93.1%
Negatives 0
Negatives (%) 0.0%
  • LastFiscalYearDonation is skewed right (γ1 = 183.5974)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 1
Maximum 10000000
Range 10000000
IQR 0

Descriptive Statistics

Mean 377.6168
Standard Deviation 54048.3693
Variance 2.9212e+09
Sum 1.3031e+07
Skewness 183.5974
Kurtosis 33953.0792
Coefficient of Variation 143.1302
  • LastFiscalYearDonation is not normally distributed (p-value 4.22651600771626e-25)
  • LastFiscalYearDonation has 2369 outliers

Donation2FiscalYearsAgo

numerical

Approximate Distinct Count 189
Approximate Unique (%) 0.5%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 552128
Mean 96.2011
Minimum 0
Maximum 1932960
Zeros 32032
Zeros (%) 92.8%
Negatives 0
Negatives (%) 0.0%
  • Donation2FiscalYearsAgo is skewed right (γ1 = 183.1952)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 25
Maximum 1932960
Range 1932960
IQR 0

Descriptive Statistics

Mean 96.2011
Standard Deviation 10454.7132
Variance 1.093e+08
Sum 3.3197e+06
Skewness 183.1952
Kurtosis 33855.5723
Coefficient of Variation 108.6757
  • Donation2FiscalYearsAgo is not normally distributed (p-value 4.226515770693045e-25)
  • Donation2FiscalYearsAgo has 2476 outliers

Donation3FiscalYearsAgo

numerical

Approximate Distinct Count 188
Approximate Unique (%) 0.5%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 552128
Mean 63.7549
Minimum 0
Maximum 500000
Zeros 31971
Zeros (%) 92.7%
Negatives 0
Negatives (%) 0.0%
  • Donation3FiscalYearsAgo is skewed right (γ1 = 118.0373)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 25
Maximum 500000
Range 500000
IQR 0

Descriptive Statistics

Mean 63.7549
Standard Deviation 3282.1957
Variance 1.0773e+07
Sum 2.2001e+06
Skewness 118.0373
Kurtosis 16458.0103
Coefficient of Variation 51.4814
  • Donation3FiscalYearsAgo is not normally distributed (p-value 4.2265666272555945e-25)
  • Donation3FiscalYearsAgo has 2537 outliers

Donation4FiscalYearsAgo

numerical

Approximate Distinct Count 177
Approximate Unique (%) 0.5%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 552128
Mean 57.1188
Minimum 0
Maximum 250000
Zeros 32362
Zeros (%) 93.8%
Negatives 0
Negatives (%) 0.0%
  • Donation4FiscalYearsAgo is skewed right (γ1 = 76.4564)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 1
Maximum 250000
Range 250000
IQR 0

Descriptive Statistics

Mean 57.1188
Standard Deviation 2594.5566
Variance 6.7317e+06
Sum 1.9711e+06
Skewness 76.4564
Kurtosis 6508.8006
Coefficient of Variation 45.4239
  • Donation4FiscalYearsAgo is not normally distributed (p-value 4.226536539874639e-25)
  • Donation4FiscalYearsAgo has 2146 outliers

Donation5FiscalYearsAgo

numerical

Approximate Distinct Count 182
Approximate Unique (%) 0.5%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 552128
Mean 126.6312
Minimum 0
Maximum 1250000
Zeros 32544
Zeros (%) 94.3%
Negatives 0
Negatives (%) 0.0%
  • Donation5FiscalYearsAgo is skewed right (γ1 = 114.455)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 11
Maximum 1250000
Range 1250000
IQR 0

Descriptive Statistics

Mean 126.6312
Standard Deviation 10064.3897
Variance 1.0129e+08
Sum 4.3698e+06
Skewness 114.455
Kurtosis 13899.8891
Coefficient of Variation 79.478
  • Donation5FiscalYearsAgo is not normally distributed (p-value 4.226522700738033e-25)
  • Donation5FiscalYearsAgo has 1964 outliers

CurrentFiscalYearDonation

numerical

Approximate Distinct Count 166
Approximate Unique (%) 0.5%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 552128
Mean 197.7946
Minimum 0
Maximum 2000000
Zeros 32599
Zeros (%) 94.5%
Negatives 0
Negatives (%) 0.0%
  • CurrentFiscalYearDonation is skewed right (γ1 = 118.6523)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 1
Maximum 2000000
Range 2000000
IQR 0

Descriptive Statistics

Mean 197.7946
Standard Deviation 15850.5703
Variance 2.5124e+08
Sum 6.8255e+06
Skewness 118.6523
Kurtosis 14756.0427
Coefficient of Variation 80.1365
  • CurrentFiscalYearDonation is not normally distributed (p-value 4.226522489190407e-25)
  • CurrentFiscalYearDonation has 1909 outliers

CumulativeDonationAmount

numerical

Approximate Distinct Count 1595
Approximate Unique (%) 4.6%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 552128
Mean 2363.5342
Minimum 0
Maximum 1.2222e+07
Zeros 13075
Zeros (%) 37.9%
Negatives 0
Negatives (%) 0.0%
  • CumulativeDonationAmount is skewed right (γ1 = 94.4472)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 25
Q3 144
95-th Percentile 1309
Maximum 1.2222e+07
Range 1.2222e+07
IQR 144

Descriptive Statistics

Mean 2363.5342
Standard Deviation 113801.4399
Variance 1.2951e+10
Sum 8.1561e+07
Skewness 94.4472
Kurtosis 9612.7056
Coefficient of Variation 48.1488
  • CumulativeDonationAmount is not normally distributed (p-value 4.226550410962558e-25)
  • CumulativeDonationAmount has 4559 outliers

DonorDateOfBirth

categorical

Approximate Distinct Count 4812
Approximate Unique (%) 36.1%
Missing 21190
Missing (%) 61.4%
Memory Size 984216

Length

Mean 8.9012
Standard Deviation 0.5761
Median 9
Minimum 8
Maximum 10

Sample

1st row 6/16/1985
2nd row 12/3/1987
3rd row 9/11/1950
4th row 1/23/1961
5th row 9/14/1978

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 91910

DonorIndicatorFlag.

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 2277528
  • The largest value (Y) is over 1.64 times larger than the second largest value (N)

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row Y
2nd row Y
3rd row Y
4th row N
5th row Y

Letter

Count 34508
Lowercase Letter 0
Space Separator 0
Uppercase Letter 34508
Dash Punctuation 0
Decimal Number 0
  • The top 2 categories (Y, N) take over 50.0%
  • The largest value (y) is over 1.64 times larger than the second largest value (n)
  • DonorIndicatorFlag. has words of constant length

Interactions

Correlations

Missing Values